-- Docs: https://www.postgresql.org/docs/current/app-psql.html

-- Don't display the "helpful" message on startup.
\set QUIET 1
\pset null '[NULL]'

-- https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-PROMPTING
\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# '

-- PROMPT2 is printed when the prompt expects more input, like when you type
-- SELECT * FROM<enter>. %R shows what type of input it expects.
\set PROMPT2 '[more] %R > '

-- Show how long each query takes to execute
\timing on

-- Use best available output format
\x auto
\set VERBOSITY verbose
\set HISTFILE ~/.psql_history- :DBNAME
\set HISTCONTROL ignoredups
\set COMP_KEYWORD_CASE upper
\unset QUIET

-- Uncomment next line and set personal settings there.
-- \i ~/.psqlrc.local